Evaluate(Object[]) Method

The args contains three items: value, value_if_error.

Value is the argument that is checked for an error.

Value_if_error is the value to return if the formula evaluates to an error. The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.

Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula. Use the IFERROR function to trap and handle errors in a formula (formula: A sequence of values, cell references, names, functions, or operators in a cell that together produce a new value. A formula always begins with an equal sign (=).).

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Overrides Function Evaluate( _
   ByVal args() As System.Object _
) As System.Object

'Usage
 
Dim instance As CalcIfErrorFunction
Dim args() As System.Object
Dim value As System.Object
 
value = instance.Evaluate(args)

public override System.object Evaluate( 
   System.object[] args
)

Parameters

args

The args contains three items: value, value_if_error.

Value is the argument that is checked for an error.

Value_if_error is the value to return if the formula evaluates to an error. The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.

Return Value

A System.Object value that indicates the evaluate result.

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

Reference

CalcIfErrorFunction Class
CalcIfErrorFunction Members
Overload List